package com.stars.questions.deptQuestion.publish.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.stars.questions.deptQuestion.publish.entity.Reply;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;

/**
 * 数据库映射
 */
@Mapper
public interface PublishMapper extends BaseMapper<Reply> {

    //年底清空提交用户信息
    @Update("UPDATE QUESTION_REPLY SET USERNAME='***',AGE=NULL,MOBILE=NULL,ADDRESS=NULL,EMAIL=NULL,WORK=NULL,CARDID=NULL WHERE YEAR=#{YEAR} ")
    boolean clearUserInfo(int year);

}
